CREATE TABLE [dbo].[City]
(
[Id] [int] NOT NULL,
[CountryId] [int] NOT NULL CONSTRAINT [DF__tbl_city__countr__473C8FC7] DEFAULT ('0'),
[RegionId] [int] NOT NULL CONSTRAINT [DF__tbl_city__region__4830B400] DEFAULT ('0'),
[Name] [nvarchar] (128) COLLATE Cyrillic_General_CI_AS NOT NULL CONSTRAINT [DF__tbl_city__city_n__4924D839] DEFAULT (''),
[IsVisible] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[City] ADD CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[City] ADD CONSTRAINT [FK_City_Country] FOREIGN KEY ([CountryId]) REFERENCES [dbo].[Country] ([Id])
GO
ALTER TABLE [dbo].[City] ADD CONSTRAINT [FK_City_Region] FOREIGN KEY ([RegionId]) REFERENCES [dbo].[Region] ([Id])
GO
